﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Animation;
using System.Windows.Shapes;
using Microsoft.Phone.Controls;
using SQLiteClient;
using CSKLiteWindowsPhone.Common;

namespace CSKLiteWindowsPhone
{
    public partial class ProxyConfig : PhoneApplicationPage
    {
        SQLiteConnection _db = Utility.GetConnection();       
        public ProxyConfig()
        {
            InitializeComponent();
            this.Loaded += new RoutedEventHandler(ProxyConfig_Loaded);
        }

        void ProxyConfig_Loaded(object sender, RoutedEventArgs e)
        {
            SQLiteCommand cmd = this._db.CreateCommand("select * from Proxy");
            IEnumerable<Proxy> tests = cmd.ExecuteQuery<Proxy>();

            this.listProxy.ItemsSource = tests;
        }

    }
}